package model.agent.service;


import model.agent.entity.Agent;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import org.springframework.data.domain.Sort;

import java.util.List;

/**
 * Created by Administrator on 2019/6/25.
 */
public interface IAgentService {
    @Select("select * from Agent where name like concat('%',#{name},'%') ")
    List<Agent> findall();

    @Select("select * from Agent where address like concat('%',#{address},'%')")
    List<Agent> getByAddress(String address);

    @Select("select * from Agent where turnover like concat('%',#{turnover},'%')")
    List<Agent> getByturnover(String turnover);

    @Select("select * from Agent where overallscore like concat('%',#{overallscore},'%')")
    List<Agent> getByoverallscore(String overallscore);

    @Select("select * from Agent where takelooklike concat('%',#{takelook},'%')")
    List<Agent> getBytooklook(String takelook);
    @Delete("delete from Agent where name=#{name}")
    void  del(String name);
    List<Agent> findsort();

}
